package com.pingan.agentbank.aaos.dao;
/**
 * Title:
 * Description:Generate by isql(lianght).
 * @Copyright: Copyright (c) 2008
 * @Company: CORSWORK
 * @author: lianght
 * @version: 1.0.0
 * @time: Fri Nov 23 10:29:17 CST 2018
 *
 * Create by isql command:
 *
 */

import com.pingan.agentbank.aaos.pojo.ApproLineInfo;
import com.pingan.vframe.db.DBIterator;
import com.pingan.vframe.db.EntityDao;
import com.pingan.vframe.db.SqlParam;

import java.util.List;

/**
 * Class description:ApproLineDao
 *
 * @author
 */
public abstract class ApproLineDao extends EntityDao<ApproLineInfo> {
	@SqlParam(condition="file_id = :fileId")
	public abstract List<ApproLineInfo> pageApproLineInfos(long fileId,int offset, int limit);

	@SqlParam(condition = "file_id = :fileId")
	public abstract int deleteByFileId(long fileId);

	@SqlParam(condition = "file_id = :fileId")
	public abstract List<ApproLineInfo> queryByFileId(long fileId);

	@SqlParam(condition = "file_id = :fileId")
	public abstract DBIterator<ApproLineInfo> queryByFileIdDb(long fileId);

	@SqlParam(condition = "file_id = :fileId",forUpdate=true)
	public abstract DBIterator<ApproLineInfo> queryByFileIdForUpdate(long fileId);



}
